SQL для тестировщика

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

www.tg-me.com/ar/SQL для тестировщика/com.sql_for_qa/116

2.0K viewsJun 30, 2023 at 09:11

tg-me.com/sql_for_qa/116

Create: 2023-06-30
Last Update: 2025-07-01 21:57:04

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/116

SQL для тестировщика Telegram | DID YOU KNOW?

In many cases, the content resembled that of the marketplaces found on the dark web, a group of hidden websites that are popular among hackers and accessed using specific anonymising software.“We have recently been witnessing a 100 per cent-plus rise in Telegram usage by cybercriminals,” said Tal Samra, cyber threat analyst at Cyberint.The rise in nefarious activity comes as users flocked to the encrypted chat app earlier this year after changes to the privacy policy of Facebook-owned rival WhatsApp prompted many to seek out alternatives.

Export WhatsApp stickers to Telegram on iPhone

You can’t. What you can do, though, is use WhatsApp’s and Telegram’s web platforms to transfer stickers. It’s easy, but might take a while.Open WhatsApp in your browser, find a sticker you like in a chat, and right-click on it to save it as an image. The file won’t be a picture, though—it’s a webpage and will have a .webp extension. Don’t be scared, this is the way. Repeat this step to save as many stickers as you want.Then, open Telegram in your browser and go into your Saved messages chat. Just as you’d share a file with a friend, click the Share file button on the bottom left of the chat window (it looks like a dog-eared paper), and select the .webp files you downloaded. Click Open and you’ll see your stickers in your Saved messages chat. This is now your sticker depository. To use them, forward them as you would a message from one chat to the other: by clicking or long-pressing on the sticker, and then choosing Forward.